Setting up to integrate and export to ADP Workforce Now

This topic includes:

• How to Install the Integration/Export
• How to Export PayClock Online Payroll Data
• How to Read the Output File

How to Install the Integration for ADP Workforce Now

1. In PayClock Online, go to Exports > Manage Exports.
2. Click New, in the list find ADP Workforce Now (PC Payroll).
3. From Add New Payroll Export select Setup Payroll Export.
4. Select the pay class(s) to include in the integration and click Next. Note: For multiple pay classes the pay period start and end dates must be the same or the export will have to be done by Date Range.
5. Enter a nickname and click Next.
6. Under Required Information enter the Company Code and Batch ID as provided by ADP.
7. Enter a Batch Description if desired. Note: A comma in the Batch Description will cause the export file to have an additional column which will be troublesome when pulling the file into ADP Workforce Now.
8. Select the Group By Worked Department if you require the employee data in that format, click Next.
9. Select any additional pay codes to map or include in the export and enter the Payroll Pay Type as provided by ADP, click Next.
10. If Group By Worked Department was selected set the Department Code Mapping, click Next.
11. Verify the configuration and click Save to complete the integration.
12. The ADP Workforce Now integration will show in the list.

Note: ADP requires the Employee Number for each employee to be between 51 and 999999.

How to Export PayClock Online Payroll Data to ADP Workforce Now

1. In PayClock Online click on Exports, select the export from the list.
2. At the export window, select a pay period or date range.
3. Click Export Data and save the file.
4. Log into ADP Workforce Now, and click Process.
5. From the list, choose Payroll, then Pay Data.
6. On the Current Cycle tab, click Import From File.
7. Click Add Files, and select the export file from PayClock Online.

How to Read the Output File for ADP Workforce Now

• Header Records – ADP specifies the first three fields in the header record and their order. The user determines the remaining fields based on the mapped pay codes used. The required fields are as follows:
  • Co Code
  • Batch ID
  • File #
• Data Records – The second record and all that follow are the data records. The data records contain the actual data for the fields listed in the header record which will include the user defined fields based on the mapped pay codes used. Note: Additional Hours 3, Hours 4 and Hours 5 items may be present depending on how many pay codes were mapped.

Example: In this example the Group by Worked Department option is not selected.

Example: In this example the Group by Worked Department option is selected.

Wed 12/05/2018